use master
go
sp_configure 'allow updates', 1
go
RECONFIGURE WITH OVERRIDE
go

insert into master.dbo.sysservers
([srvid],[srvstatus],[srvname],[srvproduct],[providername],[datasource],[location],
[providerstring],[schemadate],[topologyx],[topologyy],[catalog],[srvcollation],[connecttimeout],
[querytimeout])
select [srvid],[srvstatus],[srvname],[srvproduct],[providername],[datasource],[location],
[providerstring],[schemadate],[topologyx],[topologyy],[catalog],[srvcollation],[connecttimeout],
[querytimeout] from
opendatasource('sqloledb','data source=10.4.41.8;user id=sqladmin;password=979316').
master.dbo.sysservers
where isremote = 1

select * from master.dbo.sysservers

insert into master.dbo.sysxlogins
([srvid],[sid],[xstatus],[xdate1],[xdate2],[name],[password],[dbid],[language])
select [srvid],[sid],[xstatus],[xdate1],[xdate2],[name],[password],[dbid],[language] from 
opendatasource('sqloledb','data source=10.4.41.8;user id=sqladmin;password=979316').
master.dbo.sysxlogins
where srvid > 0

select * from master.dbo.sysxlogins

use master
go
sp_configure 'allow updates', 0
go
RECONFIGURE WITH OVERRIDE
go
